package sakila.dal.film.table;

/**
 * The film table is a list of all films potentially in stock in the store. The actual in-stock
 * copies of each film are represented in the inventory table. The film table refers to the language
 * table and is referred to the by film_category, film_actor, and inventory tables
 */
public final class film
{

	/** The table name. */
	public static final String TABLE_NAME = "film";

	/** A surrogate primary key used to uniquely identify each film in the table. */
	public static final String film_id = "film_id";

	/** The title of the film. */
	public static final String title = "title";

	/** A short description or plot summary of the film. */
	public static final String description = "description";

	/** The year in which the movies was released. */
	public static final String release_year = "release_year";

	/** A foreign key pointing at the language table, identifies the language of the film. */
	public static final String language_id = "language_id";

	/**
	 * A foreign key pointing at the language table, identifies the original language of the film.
	 * Used when the film has been dubbed into a new language.
	 */
	public static final String original_language_id = "original_language_id";

	/** The range of the rental period, in days. */
	public static final String rental_duration = "rental_duration";

	/** The cost to rent the film for the period specified in the rental_duration column. */
	public static final String rental_rate = "rental_rate";

	/** The length of the film, in minutes. */
	public static final String length = "length";

	/** The amount charged to the customer if the film is not return or return in a damaged state. */
	public static final String replacement_cost = "replacement_cost";

	/** The rating assigned to the film. Can be one of: G, PG, PG-13, R, or NC-17 */
	public static final String rating = "rating";

	/**
	 * Lists which common special features are included on the DVD. Can be zero or more of:
	 * Trailers, Commentaries, Deleted Scenes, Behind the Scenes
	 */
	public static final String special_features = "special_features";

	/** The time that the row was create or most recently updated. */
	public static final String last_update = "last_update";

	/**
	 * Instantiates a new film.
	 */
	private film()
	{
	}

}
